<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="ew142834">gp_distributed_log</title>
  <body>
    <p>The <codeph>gp_distributed_log</codeph> view contains status information about distributed
      transactions and their associated local transactions. A distributed transaction is a
      transaction that involves modifying data on the segment instances. Greenplum's distributed transaction manager ensures that the segments
      stay in synch. This view allows you to see the status of distributed transactions.</p>
    <table id="ew142842">
      <title>pg_catalog.gp_distributed_log</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="131pt"/>
        <colspec colnum="2" colname="col2" colwidth="73pt"/>
        <colspec colnum="3" colname="col3" colwidth="114.75pt"/>
        <colspec colnum="4" colname="col4" colwidth="145pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col3">references</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1">
              <codeph>segment_id</codeph>
            </entry>
            <entry colname="col2">smallint</entry>
            <entry colname="col3">gp_segment_configuration.content</entry>
            <entry colname="col4">The content id of the segment. The master is always -1 (no
              content).</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>dbid</codeph>
            </entry>
            <entry colname="col2">small_int</entry>
            <entry colname="col3">gp_segment_configuration.dbid</entry>
            <entry colname="col4">The unique id of the segment instance. </entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>distributed_xid</codeph>
            </entry>
            <entry colname="col2">xid</entry>
            <entry colname="col3"/>
            <entry colname="col4">The global transaction id.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>distributed_id</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3"/>
            <entry colname="col4">A system assigned ID for a distributed transaction.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>status</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3"/>
            <entry colname="col4">The status of the distributed transaction (Committed or
              Aborted).</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>local_transaction</codeph>
            </entry>
            <entry colname="col2">xid</entry>
            <entry colname="col3"/>
            <entry colname="col4">The local transaction ID.</entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
